package com.jc.ds.model;

import java.math.BigDecimal;

/**
 * order_products
 * @author 
 */
public class OrderProducts extends BaseValueObject {
    /**
     * 自动累加订单明细号
     */
    private Long id;

    /**
     * 父id自关联 关联当前表ID字段, 用于拆分逻辑捆绑销售的商品
     */
    private Long pId;

    /**
     * 订单号
     */
    private Long orderId;

    /**
     * 商品号
     */
    private String productSn;

    /**
     * 真正的供应商系统推送过来的，在供应商系统中的ID
     */
    private String supplierProductId;

    /**
     * 供应商SKU 表中主键
     */
    private String supplierSkuId;

    /**
     * 商品名称
     */
    private String productName;

    /**
     * 条形码
     */
    private String barCode;

    /**
     * 外部渠道编码 各供应商平台的唯一ID， 若是自营仓库发货，则这个字段存仓库产品ID
     */
    private String channelProductSn;

    /**
     * 商品数量
     */
    private Integer productNums;

    /**
     * 市场价单价
     */
    private BigDecimal normalPrice;

    /**
     * 建议售价
     */
    private BigDecimal advicePrice;

    /**
     * 推广单价
     */
    private BigDecimal salePrice;

    /**
     * 销售金额
     */
    private BigDecimal totalAmount;

    /**
     * 可得积分
     */
    private Integer points;

    /**
     * 残次级别（normal：正品；bad_one：一残；bad_two:二残；bad_three：三残）
     */
    private String productType;

    /**
     * 发货数量
     */
    private Integer sentNums;

    /**
     * 退货数量
     */
    private Integer returnNums;

    /**
     * 备注
     */
    private String memo;

    /**
     * 修改人
     */
    private Integer editor;

    /**
     * 最后修改时间
     */
    private Long editTime;

    /**
     * 是否为赠品true 是 ；false 不是
     */
    private String isGift;

    /**
     * 字符串赠品类型
     */
    private String giftType;

    /**
     * 手工调整金额
     */
    private BigDecimal adjustFee;

    /**
     * 折扣金额
     */
    private BigDecimal discountFee;

    /**
     * 是否为捆绑商品0：否，1：是
     */
    private Integer isBind;

    /**
     * 是否子商品 0:否 1:是
     */
    private Integer subGoods;

    /**
     * 是否退货的标识
     */
    private String retyrnFlag;

    /**
     * 是否删除
     */
    private String isDelete;

    /**
     * 扩展字段
     */
    private String extend1;

    /**
     * 扩展字段
     */
    private String extend2;

    /**
     * 扩展字段
     */
    private String extend3;

    /**
     * 扩展字段
     */
    private String extend4;

    /**
     * 扩展字段
     */
    private String extend5;

    /**
     * 供应商售后单ID 申请售后的时候需要用
     */
    private String supplierReturnId;

    /**
     * 供应商子订单ID  在供应商处唯一
     */
    private String supplierChildOrderId;

    /**
     * 物流公司
     */
    private String expressCompany;

    /**
     * 物流单号
     */
    private String expressNo;

    /**
     * 集速豆分摊到产品的金额 
     */
    private Long balancePaidAmount;

    private String orderStr = null;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Long getpId() {
        return pId;
    }

    public void setpId(Long pId) {
        this.pId = pId;
    }

    public Long getOrderId() {
        return orderId;
    }

    public void setOrderId(Long orderId) {
        this.orderId = orderId;
    }

    public String getProductSn() {
        return productSn;
    }

    public void setProductSn(String productSn) {
        this.productSn = productSn;
    }

    public String getSupplierProductId() {
        return supplierProductId;
    }

    public void setSupplierProductId(String supplierProductId) {
        this.supplierProductId = supplierProductId;
    }

    public String getSupplierSkuId() {
        return supplierSkuId;
    }

    public void setSupplierSkuId(String supplierSkuId) {
        this.supplierSkuId = supplierSkuId;
    }

    public String getProductName() {
        return productName;
    }

    public void setProductName(String productName) {
        this.productName = productName;
    }

    public String getBarCode() {
        return barCode;
    }

    public void setBarCode(String barCode) {
        this.barCode = barCode;
    }

    public String getChannelProductSn() {
        return channelProductSn;
    }

    public void setChannelProductSn(String channelProductSn) {
        this.channelProductSn = channelProductSn;
    }

    public Integer getProductNums() {
        return productNums;
    }

    public void setProductNums(Integer productNums) {
        this.productNums = productNums;
    }

    public BigDecimal getNormalPrice() {
        return normalPrice;
    }

    public void setNormalPrice(BigDecimal normalPrice) {
        this.normalPrice = normalPrice;
    }

    public BigDecimal getAdvicePrice() {
        return advicePrice;
    }

    public void setAdvicePrice(BigDecimal advicePrice) {
        this.advicePrice = advicePrice;
    }

    public BigDecimal getSalePrice() {
        return salePrice;
    }

    public void setSalePrice(BigDecimal salePrice) {
        this.salePrice = salePrice;
    }

    public BigDecimal getTotalAmount() {
        return totalAmount;
    }

    public void setTotalAmount(BigDecimal totalAmount) {
        this.totalAmount = totalAmount;
    }

    public Integer getPoints() {
        return points;
    }

    public void setPoints(Integer points) {
        this.points = points;
    }

    public String getProductType() {
        return productType;
    }

    public void setProductType(String productType) {
        this.productType = productType;
    }

    public Integer getSentNums() {
        return sentNums;
    }

    public void setSentNums(Integer sentNums) {
        this.sentNums = sentNums;
    }

    public Integer getReturnNums() {
        return returnNums;
    }

    public void setReturnNums(Integer returnNums) {
        this.returnNums = returnNums;
    }

    public String getMemo() {
        return memo;
    }

    public void setMemo(String memo) {
        this.memo = memo;
    }

    public Integer getEditor() {
        return editor;
    }

    public void setEditor(Integer editor) {
        this.editor = editor;
    }

    public Long getEditTime() {
        return editTime;
    }

    public void setEditTime(Long editTime) {
        this.editTime = editTime;
    }

    public String getIsGift() {
        return isGift;
    }

    public void setIsGift(String isGift) {
        this.isGift = isGift;
    }

    public String getGiftType() {
        return giftType;
    }

    public void setGiftType(String giftType) {
        this.giftType = giftType;
    }

    public BigDecimal getAdjustFee() {
        return adjustFee;
    }

    public void setAdjustFee(BigDecimal adjustFee) {
        this.adjustFee = adjustFee;
    }

    public BigDecimal getDiscountFee() {
        return discountFee;
    }

    public void setDiscountFee(BigDecimal discountFee) {
        this.discountFee = discountFee;
    }

    public Integer getIsBind() {
        return isBind;
    }

    public void setIsBind(Integer isBind) {
        this.isBind = isBind;
    }

    public Integer getSubGoods() {
        return subGoods;
    }

    public void setSubGoods(Integer subGoods) {
        this.subGoods = subGoods;
    }

    public String getRetyrnFlag() {
        return retyrnFlag;
    }

    public void setRetyrnFlag(String retyrnFlag) {
        this.retyrnFlag = retyrnFlag;
    }

    public String getIsDelete() {
        return isDelete;
    }

    public void setIsDelete(String isDelete) {
        this.isDelete = isDelete;
    }

    public String getExtend1() {
        return extend1;
    }

    public void setExtend1(String extend1) {
        this.extend1 = extend1;
    }

    public String getExtend2() {
        return extend2;
    }

    public void setExtend2(String extend2) {
        this.extend2 = extend2;
    }

    public String getExtend3() {
        return extend3;
    }

    public void setExtend3(String extend3) {
        this.extend3 = extend3;
    }

    public String getExtend4() {
        return extend4;
    }

    public void setExtend4(String extend4) {
        this.extend4 = extend4;
    }

    public String getExtend5() {
        return extend5;
    }

    public void setExtend5(String extend5) {
        this.extend5 = extend5;
    }

    public String getSupplierReturnId() {
        return supplierReturnId;
    }

    public void setSupplierReturnId(String supplierReturnId) {
        this.supplierReturnId = supplierReturnId;
    }

    public String getSupplierChildOrderId() {
        return supplierChildOrderId;
    }

    public void setSupplierChildOrderId(String supplierChildOrderId) {
        this.supplierChildOrderId = supplierChildOrderId;
    }

    public String getExpressCompany() {
        return expressCompany;
    }

    public void setExpressCompany(String expressCompany) {
        this.expressCompany = expressCompany;
    }

    public String getExpressNo() {
        return expressNo;
    }

    public void setExpressNo(String expressNo) {
        this.expressNo = expressNo;
    }

    public Long getBalancePaidAmount() {
        return balancePaidAmount;
    }

    public void setBalancePaidAmount(Long balancePaidAmount) {
        this.balancePaidAmount = balancePaidAmount;
    }

    public void orderById(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by id asc";
            }else{
                this.orderStr = this.orderStr + ",id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by id desc";
            }else{
                this.orderStr = this.orderStr + ",id desc";
            }
        }
    }

    public void orderByPId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by p_id asc";
            }else{
                this.orderStr = this.orderStr + ",p_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by p_id desc";
            }else{
                this.orderStr = this.orderStr + ",p_id desc";
            }
        }
    }

    public void orderByOrderId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by order_id asc";
            }else{
                this.orderStr = this.orderStr + ",order_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by order_id desc";
            }else{
                this.orderStr = this.orderStr + ",order_id desc";
            }
        }
    }

    public void orderByProductSn(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by product_sn asc";
            }else{
                this.orderStr = this.orderStr + ",product_sn asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by product_sn desc";
            }else{
                this.orderStr = this.orderStr + ",product_sn desc";
            }
        }
    }

    public void orderBySupplierProductId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by supplier_product_id asc";
            }else{
                this.orderStr = this.orderStr + ",supplier_product_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by supplier_product_id desc";
            }else{
                this.orderStr = this.orderStr + ",supplier_product_id desc";
            }
        }
    }

    public void orderBySupplierSkuId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by supplier_sku_id asc";
            }else{
                this.orderStr = this.orderStr + ",supplier_sku_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by supplier_sku_id desc";
            }else{
                this.orderStr = this.orderStr + ",supplier_sku_id desc";
            }
        }
    }

    public void orderByProductName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by product_name asc";
            }else{
                this.orderStr = this.orderStr + ",product_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by product_name desc";
            }else{
                this.orderStr = this.orderStr + ",product_name desc";
            }
        }
    }

    public void orderByBarCode(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by bar_code asc";
            }else{
                this.orderStr = this.orderStr + ",bar_code asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by bar_code desc";
            }else{
                this.orderStr = this.orderStr + ",bar_code desc";
            }
        }
    }

    public void orderByChannelProductSn(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by channel_product_sn asc";
            }else{
                this.orderStr = this.orderStr + ",channel_product_sn asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by channel_product_sn desc";
            }else{
                this.orderStr = this.orderStr + ",channel_product_sn desc";
            }
        }
    }

    public void orderByProductNums(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by product_nums asc";
            }else{
                this.orderStr = this.orderStr + ",product_nums asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by product_nums desc";
            }else{
                this.orderStr = this.orderStr + ",product_nums desc";
            }
        }
    }

    public void orderByNormalPrice(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by normal_price asc";
            }else{
                this.orderStr = this.orderStr + ",normal_price asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by normal_price desc";
            }else{
                this.orderStr = this.orderStr + ",normal_price desc";
            }
        }
    }

    public void orderByAdvicePrice(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by advice_price asc";
            }else{
                this.orderStr = this.orderStr + ",advice_price asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by advice_price desc";
            }else{
                this.orderStr = this.orderStr + ",advice_price desc";
            }
        }
    }

    public void orderBySalePrice(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by sale_price asc";
            }else{
                this.orderStr = this.orderStr + ",sale_price asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by sale_price desc";
            }else{
                this.orderStr = this.orderStr + ",sale_price desc";
            }
        }
    }

    public void orderByTotalAmount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by total_amount asc";
            }else{
                this.orderStr = this.orderStr + ",total_amount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by total_amount desc";
            }else{
                this.orderStr = this.orderStr + ",total_amount desc";
            }
        }
    }

    public void orderByPoints(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by points asc";
            }else{
                this.orderStr = this.orderStr + ",points asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by points desc";
            }else{
                this.orderStr = this.orderStr + ",points desc";
            }
        }
    }

    public void orderByProductType(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by product_type asc";
            }else{
                this.orderStr = this.orderStr + ",product_type asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by product_type desc";
            }else{
                this.orderStr = this.orderStr + ",product_type desc";
            }
        }
    }

    public void orderBySentNums(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by sent_nums asc";
            }else{
                this.orderStr = this.orderStr + ",sent_nums asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by sent_nums desc";
            }else{
                this.orderStr = this.orderStr + ",sent_nums desc";
            }
        }
    }

    public void orderByReturnNums(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by return_nums asc";
            }else{
                this.orderStr = this.orderStr + ",return_nums asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by return_nums desc";
            }else{
                this.orderStr = this.orderStr + ",return_nums desc";
            }
        }
    }

    public void orderByMemo(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by memo asc";
            }else{
                this.orderStr = this.orderStr + ",memo asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by memo desc";
            }else{
                this.orderStr = this.orderStr + ",memo desc";
            }
        }
    }

    public void orderByEditor(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by editor asc";
            }else{
                this.orderStr = this.orderStr + ",editor asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by editor desc";
            }else{
                this.orderStr = this.orderStr + ",editor desc";
            }
        }
    }

    public void orderByEditTime(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by edit_time asc";
            }else{
                this.orderStr = this.orderStr + ",edit_time asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by edit_time desc";
            }else{
                this.orderStr = this.orderStr + ",edit_time desc";
            }
        }
    }

    public void orderByIsGift(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by is_gift asc";
            }else{
                this.orderStr = this.orderStr + ",is_gift asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by is_gift desc";
            }else{
                this.orderStr = this.orderStr + ",is_gift desc";
            }
        }
    }

    public void orderByGiftType(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by gift_type asc";
            }else{
                this.orderStr = this.orderStr + ",gift_type asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by gift_type desc";
            }else{
                this.orderStr = this.orderStr + ",gift_type desc";
            }
        }
    }

    public void orderByAdjustFee(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by adjust_fee asc";
            }else{
                this.orderStr = this.orderStr + ",adjust_fee asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by adjust_fee desc";
            }else{
                this.orderStr = this.orderStr + ",adjust_fee desc";
            }
        }
    }

    public void orderByDiscountFee(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by discount_fee asc";
            }else{
                this.orderStr = this.orderStr + ",discount_fee asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by discount_fee desc";
            }else{
                this.orderStr = this.orderStr + ",discount_fee desc";
            }
        }
    }

    public void orderByIsBind(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by is_bind asc";
            }else{
                this.orderStr = this.orderStr + ",is_bind asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by is_bind desc";
            }else{
                this.orderStr = this.orderStr + ",is_bind desc";
            }
        }
    }

    public void orderBySubGoods(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by sub_goods asc";
            }else{
                this.orderStr = this.orderStr + ",sub_goods asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by sub_goods desc";
            }else{
                this.orderStr = this.orderStr + ",sub_goods desc";
            }
        }
    }

    public void orderByRetyrnFlag(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by retyrn_flag asc";
            }else{
                this.orderStr = this.orderStr + ",retyrn_flag asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by retyrn_flag desc";
            }else{
                this.orderStr = this.orderStr + ",retyrn_flag desc";
            }
        }
    }

    public void orderByIsDelete(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by is_delete asc";
            }else{
                this.orderStr = this.orderStr + ",is_delete asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by is_delete desc";
            }else{
                this.orderStr = this.orderStr + ",is_delete desc";
            }
        }
    }

    public void orderByExtend1(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend1 asc";
            }else{
                this.orderStr = this.orderStr + ",extend1 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend1 desc";
            }else{
                this.orderStr = this.orderStr + ",extend1 desc";
            }
        }
    }

    public void orderByExtend2(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend2 asc";
            }else{
                this.orderStr = this.orderStr + ",extend2 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend2 desc";
            }else{
                this.orderStr = this.orderStr + ",extend2 desc";
            }
        }
    }

    public void orderByExtend3(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend3 asc";
            }else{
                this.orderStr = this.orderStr + ",extend3 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend3 desc";
            }else{
                this.orderStr = this.orderStr + ",extend3 desc";
            }
        }
    }

    public void orderByExtend4(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend4 asc";
            }else{
                this.orderStr = this.orderStr + ",extend4 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend4 desc";
            }else{
                this.orderStr = this.orderStr + ",extend4 desc";
            }
        }
    }

    public void orderByExtend5(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend5 asc";
            }else{
                this.orderStr = this.orderStr + ",extend5 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend5 desc";
            }else{
                this.orderStr = this.orderStr + ",extend5 desc";
            }
        }
    }

    public void orderBySupplierReturnId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by supplier_return_id asc";
            }else{
                this.orderStr = this.orderStr + ",supplier_return_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by supplier_return_id desc";
            }else{
                this.orderStr = this.orderStr + ",supplier_return_id desc";
            }
        }
    }

    public void orderBySupplierChildOrderId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by supplier_child_order_id asc";
            }else{
                this.orderStr = this.orderStr + ",supplier_child_order_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by supplier_child_order_id desc";
            }else{
                this.orderStr = this.orderStr + ",supplier_child_order_id desc";
            }
        }
    }

    public void orderByExpressCompany(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by express_company asc";
            }else{
                this.orderStr = this.orderStr + ",express_company asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by express_company desc";
            }else{
                this.orderStr = this.orderStr + ",express_company desc";
            }
        }
    }

    public void orderByExpressNo(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by express_no asc";
            }else{
                this.orderStr = this.orderStr + ",express_no asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by express_no desc";
            }else{
                this.orderStr = this.orderStr + ",express_no desc";
            }
        }
    }

    public void orderByBalancePaidAmount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by balance_paid_amount asc";
            }else{
                this.orderStr = this.orderStr + ",balance_paid_amount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by balance_paid_amount desc";
            }else{
                this.orderStr = this.orderStr + ",balance_paid_amount desc";
            }
        }
    }
}